package com.ophelisis.ibatis.handler;

import java.sql.SQLException;
import java.util.List;
import java.util.Map;

import com.ophelisis.ibatis.SqlMapper;
import com.ophelisis.persistence.domain.LogoVO;

public class handler_logo {
	/**
	 * 로고 관리 - 목록
	 */
	@SuppressWarnings("unchecked")
	public static List<LogoVO> getLogoList() throws SQLException {
		return SqlMapper.sqlMapClient.queryForList("logo.getLogoList");
	}
	
	@SuppressWarnings("unchecked")
	public static List<LogoVO> getLogoList(Map<String, Object> params) throws SQLException {
		return SqlMapper.sqlMapClient.queryForList("logo.getLogoList", params);
	}

	/**
	 * 로고 관리 - 목록 갯수
	 */
	public static Integer getLogoListCnt() throws SQLException {
		return (Integer)SqlMapper.sqlMapClient.queryForObject("logo.getLogoListCnt");
	}
	
	public static Integer getLogoListCnt(Map<String, Object> params) throws SQLException {
		return (Integer)SqlMapper.sqlMapClient.queryForObject("logo.getLogoListCnt", params);
	}

	/**
	 * 로고 관리 - 상세
	 */
	@SuppressWarnings("unchecked")
	public static List<LogoVO> getLogoDetail(Map<String, Object> params) throws SQLException {
		return SqlMapper.sqlMapClient.queryForList("logo.getLogoDetail", params);
	}

	/**
	 * 로고 관리 - 삭제
	 */
	public static Integer setLogoDelete(Map<String, Object> params) throws SQLException {
		return (Integer)SqlMapper.sqlMapClient.update("logo.setLogoDelete", params);
	}

	/**
	 * 로고 관리 - 수정
	 */
	public static Integer setLogoModify(LogoVO paramVO) throws SQLException {
		return (Integer)SqlMapper.sqlMapClient.update("logo.setLogoModify", paramVO);
	}

	/**
	 * 로고 관리 - 등록
	 */
	public static Integer setLogoAdd(LogoVO paramVO) throws SQLException {
		return (Integer)SqlMapper.sqlMapClient.update("logo.setLogoAdd", paramVO);
	}
}
